Shared memory oddity
От | Steven Lane |
---|---|
Тема | Shared memory oddity |
Дата | |
Msg-id | v03007807b83aa9d92895@[209.242.196.75] обсуждение исходный текст |
Список | pgsql-admin |
Why would this happen? I had a server where postgres appeared to be running very slowly. Following some advice I found on-line, I boosted the shared memory max for that machine and told postgres to take 15200 buffers (about 128 meg of shared memory). For a while this worked great, but today, the system runs very slowly again. free and shared memory look like this: [slane@iep slane]$ free total used free shared buffers cached Mem: 513940 511652 2288 295248 38100 371896 -/+ buffers/cache: 101656 412284 Swap: 0 0 0 [slane@iep slane]$ ipcs ------ Shared Memory Segments -------- key shmid owner perms bytes nattch status ------ Semaphore Arrays -------- key semid owner perms nsems status ------ Message Queues -------- key msqid owner perms used-bytes messages [slane@iep slane]$ cat /proc/sys/kernel.shmmax cat: /proc/sys/kernel.shmmax: No such file or directory [slane@iep slane]$ cat /proc/sys/kernel/shmmax 160000000 Postgres used to have a big section of shared memory in use. Today, nothing. postgres 7.1, running on LinuxPPC on a PowerMac G4. Any ideas? -- sgl
В списке pgsql-admin по дате отправления: